利用pandas库和ttk.Treeviews制作xlxs视图工具

参考文章：

https://blog.csdn.net/weixin_42268054/article/details/82902296
https://blog.csdn.net/qq_39410381/article/details/88867533

import tkinter as tk
from tkinter import ttk
import pandas as pd

def Start():
    fp = pd.read_excel("./test.xlsx")
    for _ in range(len(fp.index.values)):
        tree.insert('','end',value=tuple(fp.iloc[_,[1,2]].values))


win = tk.Tk()
win.wm_attributes('-topmost',1)
# win.geometry("+1300+0")

ttk.Button(win,text="Import it",command=Start).pack()

columns = ("name","gender")

tree = ttk.Treeview(win,show="headings",columns=columns)
tree.column("name",width=100,anchor='center')
tree.column("gender",width=50, anchor="center")

tree.heading("name",text="name")
tree.heading("gender",text="gender")


tree.pack()


win.mainloop()

excel图片：

结果显示: